1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Management;
11 using System.Collections;
12
13 namespace SoftQuanLyNhaHang.Views
14 {
15 public delegate void Link_Scanner_CheckSp_EventHandler(object sender, EventArgs e);
16
17
18 public partial class uctCauHinhHeThong : UserControl
19 {
20 public uctCauHinhHeThong()
21 {
22 InitializeComponent();
23 }
24
25 public static uctCauHinhHeThong uctCHHT = new uctCauHinhHeThong();
26
27 public event Link_Scanner_CheckSp_EventHandler Link_Scanner_CheckSp;
28
29 DataTable dtCauHinh = new DataTable();
30
31 string _KhoaChinh = string.Empty;
32 string _GiaTri = string.Empty;
33 string _TrangThai = "SuDung";
34 string _GhiChu= string.Empty;
35
36 string _getKhoaChinh_DauThapPhan = string.Empty;
37 string _getGiaTri_DauThapPhan = string.Empty;
38
39 string _getGiaTri_DauPhanCachHangNghin = string.Empty;
40 string _getKhoaChinh_DauPhanCach = string.Empty;
41
42 string _getSoThapPhan = string.Empty;
43
44 private void uctCauHinhHeThong_Load(object sender, EventArgs e)
45 {
46 //chon giay in
47 cmbChonGiayIn.Items.Clear();
48 cmbChonGiayIn.Items.Add("A4");
49 cmbChonGiayIn.Items.Add("A5");
50 cmbChonGiayIn.Items.Add("A6");
51 cmbChonGiayIn.Items.Add("A7");
52 cmbChonGiayIn.Items.Add("A8");
53 cmbChonGiayIn.Items.Add("A9");
54 cmbChonGiayIn.Items.Add("A10");
55
56 dtCauHinh = Controllers.CauHinhHeThongCtrl.FillDataSet_getAllCauHinhHeThong().Tables[0];
57 if (dtCauHinh.Rows.Count > 0)
58 {
59 foreach (DataRow dtRow in dtCauHinh.Rows)
60 {
61 try
62 {
63 string KhoaChinh = dtRow["KhoaChinh"].ToString();
64 switch (KhoaChinh)
65 {
66 case "DAU_PHAY":
67 {
68 _getKhoaChinh_DauThapPhan = "DAU_PHAY";
69 _getGiaTri_DauThapPhan = dtRow["GiaTri"].ToString();
70 break;
71 }
72 case "PHAN_CACH_HANG_NGHIN":
73 {
74 _getKhoaChinh_DauPhanCach = "PHAN_CACH_HANG_NGHIN";
75 _getGiaTri_DauPhanCachHangNghin = dtRow["GiaTri"].ToString();
76 break;
77 }
78 case "SO_THAP_PHAN":
79 {
80 _getSoThapPhan = dtRow["GiaTri"].ToString();
81 break;
82 }
83 case "TIEU_DE_NGU_HOA_DON_BAN_HANG":
84 {
85 txtTieuDe_BanHang.Text = dtRow["GiaTri"].ToString();
86 break;
87 }
88 case "TIEU_DE_NGU_HOA_DON_NHAP_HANG":
89 {
90 txtTieuDe_NhapHang.Text = dtRow["GiaTri"].ToString();
91 break;
92 }
93 case "TEN_CONG_TY":
94 {
95 txtTenCongTy.Text = dtRow["GiaTri"].ToString();
96 break;
97 }
98 case "DIA_CHI":
99 {
100 txtDiaChi.Text = dtRow["GiaTri"].ToString();
101 break;
102 }
103 case "WEBSITE":
104 {
105 txtWebsite.Text = dtRow["GiaTri"].ToString();
106 break;
107 }
108 case "HOTLINE":
109 {
110 txtHotline.Text = dtRow["GiaTri"].ToString();
111 break;
112 }
113 case "TIEU_DE_HOA_DON_BAN_HANG":
114 {
115 txtTieuDeHoaDonBanHang.Text = dtRow["GiaTri"].ToString();
116 break;
117 }
118 case "LUU_THONG_TIN_KHACH_MUA_HANG":
119 {
120 string luuThongTinKhachMuaHang = "checked";
121 luuThongTinKhachMuaHang = dtRow["GiaTri"].ToString();
122
123 if (luuThongTinKhachMuaHang == "checked")
124 {
125 chkLuuThongTinKhachHang.Checked = true;
126 }
127 else
128 {
129 chkLuuThongTinKhachHang.Checked = false;
130 }
131 break;
132 }
133 case "BINH_ON_GIA_BAN":
134 {
135 string binhon_giaban = "checked";
136 binhon_giaban = dtRow["GiaTri"].ToString();
137
138 if (binhon_giaban == "checked")
139 {
140 chkBinhOnGia.Checked = true;
141 }
142 else
143 {
144 chkBinhOnGia.Checked = false;
145 }
146 break;
147 }
148 case "IN_HOA_DON_SAU_KHI_BAN":
149 {
150 string In_hoa_Don_SauKhiBan = "checked";
151 In_hoa_Don_SauKhiBan = dtRow["GiaTri"].ToString();
152
153 if (In_hoa_Don_SauKhiBan == "checked")
154 {
155 chk_inHoaDonBanHangSauKhiBan.Checked = true;
156 }
157 else
158 {
159 chk_inHoaDonBanHangSauKhiBan.Checked = false;
160 }
161 break;
162 }
163 case "KI_HIEU_TIEN_TE":
164 {
165 txtKiHieuTienTe.Text = dtRow["GiaTri"].ToString();
166 break;
167 }
168 case "CHON_GIAY_IN":
169 {
170 cmbChonGiayIn.SelectedItem = dtRow["GiaTri"].ToString();
171 break;
172 }
173 case "BARCODE_THANH_TOAN_BAN_HANG":
174 {
175 txtQuetMaThanhToan.Text = dtRow["GiaTri"].ToString();
176 break;
177 }
178 case "BARCODE_THEM_MOI_KHACH_HANG":
179 {
180 txtThemMoiKh.Text = dtRow["GiaTri"].ToString();
181 break;
182 }
183 case "BARCODE_DON_HANG_CHUA_THANH_TOAN":
184 {
185 txtDonHangChuaThanhToan.Text = dtRow["GiaTri"].ToString();
186 break;
187 }
188 //
189 default:
190 {
191 //Gia tri mac dinh
192 break;
193 }
194 }
195 }
196 catch
197 {
198 }
199 }
200 }
201
202 //load all control
203 this.loadAllcontrol();
204
205
206 }
207
208
209 //hien thi all
210 private void loadAllcontrol()
211 {
212 //dấu phân cách
213 this.DauPhanCachHangNghin();
214
215 //Lấy số thập phân
216 this.SoThapPhan();
217
218 //dau thap pham
219 txtDauThapPhan.Text = _getGiaTri_DauThapPhan;
220
221 //hien thi combobox
222 cmbMacDinhNhanVienBanHang.Items.Clear();
223 cmbMacDinhNhanVienBanHang.Items.Add("Tất cả");
224 cmbMacDinhNhanVienBanHang.SelectedItem = "Tất cả";
225
226
227 //cmbChonGiayIn.SelectedItem = "A4";
228
229 }
230
231 private void DauPhanCachHangNghin()
232 {
233 //Dấu phẩy và dấu phân cách
234 cmbDauPhanCachHangNghin.Items.Clear();
235 cmbDauPhanCachHangNghin.Items.Add(",");
236 cmbDauPhanCachHangNghin.Items.Add(".");
237
238 cmbDauPhanCachHangNghin.SelectedItem = _getGiaTri_DauPhanCachHangNghin;
239
240 }
241
242 private void SoThapPhan()
243 {
244 //
245 cmbLayGiaTriSauDauPhay.Items.Clear();
246 cmbLayGiaTriSauDauPhay.Items.Add("0");
247 cmbLayGiaTriSauDauPhay.Items.Add("1");
248 cmbLayGiaTriSauDauPhay.Items.Add("2");
249 cmbLayGiaTriSauDauPhay.Items.Add("3");
250
251 cmbLayGiaTriSauDauPhay.SelectedText = _getSoThapPhan;
252 }
253
254
255 private void btnLuuCaiDat_Click(object sender, EventArgs e)
256 {
257
258 }
259
260 private void btnLuuTatCa_Click(object sender, EventArgs e)
261 {
262 this.UpdateDauThapPhan_DauPhanCachHangNghin();
263
264 this.UpdateSoThapPhan();
265
266 //tieu de hoa don ban hang
267 this.UpdateTieuDeHD_BanHang();
268 //
269 this.UpdateTieuDeNgu_NhapHang_BanHang();
270
271 //all checked box
272 this.UpdateAll_CheckedBox();
273
274 //ki hieu tien te : vnđ
275 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("KI_HIEU_TIEN_TE", txtKiHieuTienTe.Text, _TrangThai, _GhiChu);
276
277 //update giay in
278 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("CHON_GIAY_IN", cmbChonGiayIn.SelectedItem.ToString(), _TrangThai, _GhiChu);
279
280 //thong tin ve cong ty
281 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("TEN_CONG_TY", txtTenCongTy.Text.Trim(), _TrangThai, _GhiChu);
282 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("DIA_CHI", txtDiaChi.Text.Trim(), _TrangThai, _GhiChu);
283 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("WEBSITE", txtWebsite.Text.Trim(), _TrangThai, _GhiChu);
284 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("HOTLINE", txtHotline.Text.Trim(), _TrangThai, _GhiChu);
285
286 //in hoa don sau khi ban
287 //binh on gia
288 if(chk_inHoaDonBanHangSauKhiBan.Checked == true)
289 {
290 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("IN_HOA_DON_SAU_KHI_BAN", "checked", _TrangThai, _GhiChu);
291 }
292 else
293 {
294 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("IN_HOA_DON_SAU_KHI_BAN", "no_checked", _TrangThai, _GhiChu);
295 }
296
297 //barcode
298 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("BARCODE_THANH_TOAN_BAN_HANG", txtQuetMaThanhToan.Text.Trim(), _TrangThai, _GhiChu);
299 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("BARCODE_THEM_MOI_KHACH_HANG", txtThemMoiKh.Text.Trim(), _TrangThai, _GhiChu);
300
301 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("BARCODE_DON_HANG_CHUA_THANH_TOAN", txtDonHangChuaThanhToan.Text.Trim(), _TrangThai, _GhiChu);
302
303
304 lblThongBao.Visible = true;
305 var t = new System.Windows.Forms.Timer();
306 t.Interval = 3000; // it will Tick in 3 seconds
307 t.Tick += (s, ex) =>
308 {
309 lblThongBao.Visible = false;
310 t.Stop();
311 };
312 t.Start();
313
314 /////
315 //khong ket noi dc csdl thi hien form ket noi len
316 if (CauHinhHeThong.KET_NOI_CSDL == true)
317 {
318 //da ket noi dc csdl
319 dtCauHinh = Controllers.CauHinhHeThongCtrl.FillDataSet_getAllCauHinhHeThong().Tables[0];
320 if (dtCauHinh.Rows.Count > 0)
321 {
322 foreach (DataRow dtRow in dtCauHinh.Rows)
323 {
324 try
325 {
326 string KhoaChinh = dtRow["KhoaChinh"].ToString();
327 switch (KhoaChinh)
328 {
329 case "DAU_PHAY":
330 {
331 CauHinhHeThong.DAU_PHAY = dtRow["GiaTri"].ToString();
332 break;
333 }
334 case "PHAN_CACH_HANG_NGHIN":
335 {
336 CauHinhHeThong.PHAN_CACH_HANG_NGHIN = dtRow["GiaTri"].ToString();
337 break;
338 }
339 case "TIEU_DE_NGU_HOA_DON_BAN_HANG":
340 {
341 CauHinhHeThong.TIEU_DE_NGU_HOA_DON_BAN_HANG = dtRow["GiaTri"].ToString();
342 break;
343 }
344 case "TIEU_DE_NGU_HOA_DON_NHAP_HANG":
345 {
346 CauHinhHeThong.TIEU_DE_NGU_HOA_DON_NHAP_HANG = dtRow["GiaTri"].ToString();
347 break;
348 }
349 case "TIEU_DE_HOA_DON_BAN_HANG":
350 {
351 CauHinhHeThong.TIEU_DE_HOA_DON_BAN_HANG = dtRow["GiaTri"].ToString();
352 break;
353 }
354 case "LUU_THONG_TIN_KHACH_MUA_HANG":
355 {
356 CauHinhHeThong.LUU_THONG_TIN_KHACH_MUA_HANG = dtRow["GiaTri"].ToString();
357 break;
358 }
359 case "BINH_ON_GIA_BAN":
360 {
361 CauHinhHeThong.BINH_ON_GIA_BAN = dtRow["GiaTri"].ToString();
362 break;
363 }
364 case "KI_HIEU_TIEN_TE":
365 {
366 CauHinhHeThong.KI_HIEU_TIEN_TE = dtRow["GiaTri"].ToString();
367 break;
368 }
369 case "TEN_CONG_TY":
370 {
371 CauHinhHeThong.TEN_CONG_TY = dtRow["GiaTri"].ToString();
372 break;
373 }
374 case "DIA_CHI":
375 {
376 CauHinhHeThong.DIA_CHI = dtRow["GiaTri"].ToString();
377 break;
378 }
379 case "WEBSIETE":
380 {
381 CauHinhHeThong.WEBSITE = dtRow["GiaTri"].ToString();
382 break;
383 }
384 case "HOTLINE":
385 {
386 CauHinhHeThong.HOTLINE = dtRow["GiaTri"].ToString();
387 break;
388 }
389 case "PRINT_WIDTH":
390 {
391 CauHinhHeThong.PRINT_WIDTH = 444;
392 break;
393 }
394
395 case "PRINT_HEIGHT":
396 {
397 CauHinhHeThong.PRINT_HEIGHT = 630;
398 break;
399 }
400 case "IN_HOA_DON_SAU_KHI_BAN":
401 {
402 CauHinhHeThong.IN_HOA_DON_SAU_KHI_BAN = dtRow["GiaTri"].ToString();
403 break;
404 }
405 case "BARCODE_THANH_TOAN_BAN_HANG":
406 {
407 CauHinhHeThong.BARCODE_THANH_TOAN_BAN_HANG = dtRow["GiaTri"].ToString();
408 break;
409 }
410 case "BARCODE_THEM_MOI_KHACH_HANG":
411 {
412 CauHinhHeThong.BARCODE_THEM_MOI_KHACH_HANG = dtRow["GiaTri"].ToString();
413 break;
414 }
415 case "BARCODE_DON_HANG_CHUA_THANH_TOAN":
416 {
417 CauHinhHeThong.BARCODE_DON_HANG_CHUA_THANH_TOAN = dtRow["GiaTri"].ToString();
418 break;
419 }
420
421 default:
422 {
423 //Gia tri mac dinh
424 break;
425 }
426 }
427 }
428 catch
429 {
430 }
431 }
432 }
433 }
434 //
435 }
436
437 private void cmbDauPhanCachHangNghin_SelectionChangeCommitted(object sender, EventArgs e)
438 {
439 if (cmbDauPhanCachHangNghin.SelectedItem.ToString() == ".")
440 {
441 txtDauThapPhan.Text = ",";
442 }
443 else
444 {
445 txtDauThapPhan.Text = ".";
446 }
447 }
448
449 private void UpdateDauThapPhan_DauPhanCachHangNghin()
450 {
451 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("DAU_PHAY", txtDauThapPhan.Text, _TrangThai, _GhiChu);
452 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("PHAN_CACH_HANG_NGHIN", cmbDauPhanCachHangNghin.SelectedItem.ToString(), _TrangThai, _GhiChu);
453
454 }
455
456 private void UpdateSoThapPhan()
457 {
458 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("SO_THAP_PHAN", cmbLayGiaTriSauDauPhay.Text, _TrangThai, _GhiChu);
459 }
460
461 private void UpdateTieuDeNgu_NhapHang_BanHang()
462 {
463 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("TIEU_DE_NGU_HOA_DON_BAN_HANG", txtTieuDe_BanHang.Text, _TrangThai, _GhiChu);
464 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("TIEU_DE_NGU_HOA_DON_NHAP_HANG", txtTieuDe_NhapHang.Text, _TrangThai, _GhiChu);
465 }
466
467 private void UpdateTieuDeHD_BanHang()
468 {
469 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("TIEU_DE_HOA_DON_BAN_HANG", txtTieuDeHoaDonBanHang.Text, _TrangThai, _GhiChu);
470 }
471
472 private void UpdateAll_CheckedBox()
473 {
474 if (chkLuuThongTinKhachHang.Checked == true)
475 {
476 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("LUU_THONG_TIN_KHACH_MUA_HANG", "checked", _TrangThai, _GhiChu);
477 }
478 else
479 {
480 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("LUU_THONG_TIN_KHACH_MUA_HANG", "no_checked", _TrangThai, _GhiChu);
481 }
482
483 //binh on gia
484 if (chkBinhOnGia.Checked == true)
485 {
486 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("BINH_ON_GIA_BAN", "checked", _TrangThai, _GhiChu);
487 }
488 else
489 {
490 Controllers.CauHinhHeThongCtrl.UpdateCauHinhHeThong("BINH_ON_GIA_BAN", "no_checked", _TrangThai, _GhiChu);
491 }
492 }
493
494 //ArrayList hardDriveDetails = new ArrayList();
495 private void btnGetKey_Click(object sender, EventArgs e)
496 {
497
498
499 }
500
501 private void txtSystem_KeyDown(object sender, KeyEventArgs e)
502 {
503
504 }
505
506 private void linkLabel1KetThucChuongTrinhChayThu_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
507 {
508
509 }
510
511 private void btnUpDvt_Click(object sender, EventArgs e)
512 {
513
514
515 }
516
517 private void linkLabelUpdateDvt_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
518 {
519 if (chkDvt.Checked == true)
520 {
521 DialogResult dr = MessageBox.Show("Bạn có muốn Update?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
522 if (dr == DialogResult.Yes)
523 {
524 Controllers.ThongTinSanPhamCtrl.UpdateThongTinSanPhamDvt(0);
525 }
526 else
527 {
528 return;
529
530 }
531 }
532 }
533
534 private void linkLabel1SaverMaBarcodeTT_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
535 {
536
537 }
538
539 private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
540 {
541
542 }
543
544 private void btnScan_Click(object sender, EventArgs e)
545 {
546 if (this.Link_Scanner_CheckSp != null)
547 {
548 this.Link_Scanner_CheckSp(sender, e);
549 }
550 }
551
552 private void btnXoaDuLieuDeMo_Click(object sender, EventArgs e)
553 {
554 DialogResult dr = MessageBox.Show("Bạn có muốn Xoa dữ liệu DEMO?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
555 if (dr == DialogResult.Yes)
556 {
557 Controllers.CauHinhHeThongCtrl.DeleteDuLieuDemo("");
558 }
559 else
560 {
561 return;
562
563 }
564 }
565
566 private void txtsys_KeyDown(object sender, KeyEventArgs e)
567 {
568 if (e.KeyCode == Keys.Enter)
569 {
570 if (txtsys.Text.Trim() == "1")
571 {
572 pnlAn.Visible = true;
573 }
574 }
575 }
576
577
578
579 //
580 }//end class
581
582
583
584 }